Automobile complaint Analysis
Sayan Banerjee
August 2, 2017
1 Synopsis
This is analysis of complaints for an automobile company. This includes topic analysis and sentiment analysis.
Loading the required packages for the data analysis
library(ggplot2)
library(syuzhet)
library(NLP)
library(tm)
library(slam)
library(openNLP)
#library(quanteda)
library(lexRankr)
library(LSAfun)
library(RWeka)
library(cluster)
library(dendextend)
library(wordcloud)
library(topicmodels)
library(Rmpfr)
library(dplyr)
library(lazyeval)
library(stringi)
library(stringr)
library(corrplot)
library(shiny)
library(LDAvis)
library(servr)
library(igraph)
library(visNetwork)
library(RColorBrewer)
library(knitr)
library(xtable)2 User defined function
All user defined functions are currently hidden
3 Read input data
compDF <- read.csv("D:/Data Science/Automobile complaint analysis/input/auto_complaint.csv",
stringsAsFactors = F)
print(xtable(strtable(compDF)),
type="html",include.rownames = FALSE)| variable | class | levels | examples |
|---|---|---|---|
| S.No. | integer | 1, 2, 3, 4, … | |
| Complaint.Heading | character | NA, … | |
| Username | character | “”, “Abhilash Balakrishnan”, “Ashok Matadeen Kumar”, … | |
| Complaint.Text | character | NA, … |
4 Data pre-processing
4.1 Summarization for each complaint
comp_sum <- c()
# for(i in 1:nrow(comp_topicDF))
# {
# if(nsentence(comp_topicDF[i,"Complaint.Text"]) > 2)
# {
# comp_sum <- c(comp_sum,paste(genericSummary(comp_topicDF[i,"Complaint.Text"],2),
# collapse=" \n"))
# } else {
# comp_sum <- c(comp_sum,comp_topicDF[i,"Complaint.Text"])
# }
# }
for(i in 1:nrow(compDF))
{
#print(i)
comp_sum <- c(comp_sum,paste(unique(genericSummary_revised(
compDF[i,"Complaint.Text"],
k=2,
min=5)),
collapse=" \n"))
# if(length(gregexpr('[[:alnum:] ]{5}[.!?]',
# compDF[i,"Complaint.Text"])[[1]]) > 2)
# {
# comp_sum <- c(comp_sum,paste(genericSummary(gsub("[\\?|!]",".",
# compDF[i,"Complaint.Text"]),
# k=2,
# min=10),
# collapse=" \n"))
# } else {
# comp_sum <- c(comp_sum,compDF[i,"Complaint.Text"])
# }
}
compDF <- cbind.data.frame(compDF,complaint_summary = comp_sum,
stringsAsFactors = FALSE)4.1.1 Interim file
interim_directory <- "D:/Data Science/Automobile complaint analysis/processed_data"
interim_file = paste(interim_directory,"/automobile_customer_complain_interim_",
format(Sys.Date(), "%Y%m%d"),".csv",sep="")
write.csv(compDF,interim_file,row.names=FALSE)
print(paste(" \nFollowing interim file created - ",interim_file,sep=""))[1] " interim file created - D:/Data Science/Automobile complaint analysis/processed_data/automobile_customer_complain_interim_20170926.csv"
4.2 POS tagging
Visualizing POS data for few complaints
sample_pos <- tagPOS(compDF[1,"complaint_summary"])
sample_pos$POStagged[1] “My/PRP$ vehicle/NN no/RB :/: AS/IN 01/CD BV/NNP 5458/CD Hyundai/NNP Eon/NNP bought/VBD in/IN the/DT month/NN of/IN November/NNP 2015/CD But/CC after/IN that/DT every/DT day/NN they/PRP promises/VBZ to/TO return/VB my/PRP$ car/NN on/IN next/JJ day/NN”
extractPOS(compDF[831,"complaint_summary"],c("RB","NN","JJ","VBN"))extractPOS(compDF[545,"complaint_summary"],c("RB"))[1] “Later on later immediately ( ) back Kindly as soon”
We’ll extract only following POS for further analysis
RB -> Adverb
NN -> Noun, singular or mass, including NNP -> Proper noun, singular (and plural)
JJ -> Adjective
VBN -> Verb, past participle
comp_keywords <- lapply(compDF[,"complaint_summary"],
extractPOS,
POSregex_list = c("RB","NN","JJ","VBN"))
#POSregex_exclude_list = c("NNP"))
comp_keywordsDF <- as.data.frame(do.call(rbind,comp_keywords))
comp_keywordsDF[,1] <- as.character(comp_keywordsDF[,1])
comp_keywordsDF <- cbind(compDF$S.No.,comp_keywordsDF,
stringsAsFactors = FALSE)
names(comp_keywordsDF) <- c("ID","content")4.3 Stop words suggestion
recommended_stop_words <- suggest_stop_words(comp_keywordsDF,1:3,0.999)
# print(xtable(recommended_stop_words),
# type="html",include.rownames = FALSE)
recom_stop_words_file <- "D:/Data Science/Automobile complaint analysis/processed_data/suggested_stop_words.csv"
write.csv(recommended_stop_words,recom_stop_words_file,row.names=FALSE)
print(paste(" \nFollowing output file created - ",recom_stop_words_file,sep=""))[1] " output file created - D:/Data Science/Automobile complaint analysis/processed_data/suggested_stop_words.csv"
These are only recommended stop words. Need to use single words stop words from the list
4.4 DTM creation
#special_symbols <- c("<p>","</p>","<blockquote>","</blockquote>")
stop_words_file <- "D:/Data Science/Automobile complaint analysis/input/stop_words.csv"
content_DTM_1 <- dtm.generate(comp_keywordsDF,
1,0.99,
#spl_sym = special_symbols,
my_stop_word_file = stop_words_file,
keep.id=TRUE,
doIDF = FALSE)
term1_tfidf <- tapply(content_DTM_1$v/slam::row_sums(content_DTM_1)[content_DTM_1$i],
content_DTM_1$j, mean) *
log2(tm::nDocs(content_DTM_1)/slam::col_sums(content_DTM_1 > 0))
summary(term1_tfidf)Min. 1st Qu. Median Mean 3rd Qu. Max. 0.8645 1.1900 1.3350 1.3993 1.5136 2.9001
term1_tfidf_iqr <- summary(term1_tfidf)[5] - summary(term1_tfidf)[2]
content_DTM_1.reduced <- content_DTM_1[,
term1_tfidf >= (summary(term1_tfidf)[2] - 1.5 * term1_tfidf_iqr)]
# term1_tfidf <= (summary(term1_tfidf)[5] + 1.5 * term1_tfidf_iqr)]
# content_DTM_1.reduced <- content_DTM_1[,
# term1_tfidf >= (summary(term1_tfidf)[3])]
summary(slam::col_sums(content_DTM_1.reduced))Min. 1st Qu. Median Mean 3rd Qu. Max. 25.00 34.00 48.50 59.82 64.00 252.00
4.4.1 Word cloud for single words
wf_content_DTM_1 <- wf.generate(dtm=content_DTM_1.reduced,
wc_freq = 50,
wc_freq_scale = c(3, .3))
content_DTM_2 <- dtm.generate(comp_keywordsDF,
2,0.999,
#spl_sym = special_symbols,
my_stop_word_file = stop_words_file,
keep.id=TRUE,
doIDF = FALSE)
term2_tfidf <- tapply(content_DTM_2$v/slam::row_sums(content_DTM_2)[content_DTM_2$i],
content_DTM_2$j, mean) *
log2(tm::nDocs(content_DTM_2)/slam::col_sums(content_DTM_2 > 0))
summary(term2_tfidf)Min. 1st Qu. Median Mean 3rd Qu. Max. 1.994 4.312 5.389 5.443 6.467 9.701
term2_tfidf_iqr <- summary(term2_tfidf)[5] - summary(term2_tfidf)[2]
content_DTM_2.reduced <- content_DTM_2[,
term2_tfidf >= (summary(term2_tfidf)[2] - 1.5 * term2_tfidf_iqr)]
# term2_tfidf <= (summary(term2_tfidf)[5] + 1.5 * term2_tfidf_iqr)]
# content_DTM_2.reduced <- content_DTM_2[,
# term2_tfidf >= (summary(term2_tfidf)[2])]
summary(slam::col_sums(content_DTM_2.reduced))Min. 1st Qu. Median Mean 3rd Qu. Max. 3.000 3.000 4.000 4.794 5.000 26.000
#content_DTM_2.reduced$v <- content_DTM_2.reduced$v * (2^2)4.4.2 Word cloud for two consecutive words
wf_content_DTM_2 <- wf.generate(dtm=content_DTM_2.reduced,
wc_freq = 50,
wc_freq_scale = c(2, .2))
content_DTM_3 <- dtm.generate(comp_keywordsDF,
3,0.999,
#spl_sym = special_symbols,
my_stop_word_file = stop_words_file,
keep.id=TRUE,
doIDF = FALSE)
term3_tfidf <- tapply(content_DTM_3$v/slam::row_sums(content_DTM_3)[content_DTM_3$i],
content_DTM_3$j, mean) *
log2(tm::nDocs(content_DTM_3)/slam::col_sums(content_DTM_3 > 0))
summary(term3_tfidf)Min. 1st Qu. Median Mean 3rd Qu. Max. 9.701 9.701 9.701 9.701 9.701 9.701
term3_tfidf_iqr <- summary(term3_tfidf)[5] - summary(term3_tfidf)[2]
content_DTM_3.reduced <- content_DTM_3[,
term3_tfidf >= (summary(term3_tfidf)[2] - 1.5 * term3_tfidf_iqr)]
# term3_tfidf <= (summary(term3_tfidf)[5] + 1.5 * term3_tfidf_iqr)]
# content_DTM_3.reduced <- content_DTM_3[,
# term3_tfidf >= (summary(term3_tfidf))[2]]
summary(slam::col_sums(content_DTM_3.reduced))Min. 1st Qu. Median Mean 3rd Qu. Max. 3 3 3 3 3 3
#content_DTM_3.reduced$v <- content_DTM_3.reduced$v * (3^3)4.4.3 Word cloud for three consecutive words
wf_content_DTM_3 <- wf.generate(dtm=content_DTM_3.reduced,
wc_freq = 50,
wc_freq_scale = c(2, .2))
content_DTM <- cbind(content_DTM_3.reduced,content_DTM_2.reduced)
content_DTM.uncl <- remove.unclustered.dtm(content_DTM)4.4.4 Word cloud for words that will be used for topic modelling
wf_content_DTM.uncl <- wf.generate(dtm=content_DTM.uncl,
wc_freq = 50,
wc_freq_scale = c(2.5, .25),
seperator = TRUE)
5 Topic Modeling
content.lda.list <- generate.lda(content_DTM.uncl)
[1] " 2017-09-26 00:15:01 : Iteration 1 - coefficient: -0.931060237313231 - # topics: 50 " [1] " next iteration topic_num_interval: 5 , topic_start_num: 5 , topic_end_num: 55 " 
[1] " 2017-09-26 00:16:01 : Iteration 2 - coefficient: -0.861375888645061 - # topics: 20 " [1] " next iteration topic_num_interval: 5 , topic_start_num: 2 , topic_end_num: 25 " 
[1] " 2017-09-26 00:16:13 : Iteration 3 - coefficient: 0.754082664388163 - # topics: 12 " [1] " next iteration topic_num_interval: 2 , topic_start_num: 7 , topic_end_num: 17 " 
[1] " 2017-09-26 00:16:28 : Iteration 4 - coefficient: 0.783495787541179 - # topics: 11 " [1] " next iteration topic_num_interval: 2 , topic_start_num: 9 , topic_end_num: 19 " 
[1] " 2017-09-26 00:16:45 : Iteration 5 - coefficient: 0.260610061309809 - # topics: 13 " [1] " next iteration topic_num_interval: 2 , topic_start_num: 11 , topic_end_num: 21 " 
[1] " 2017-09-26 00:17:04 : Iteration 6 - coefficient: -0.0319057325169092 - # topics: 17 " [1] " next iteration topic_num_interval: 1 , topic_start_num: 15 , topic_end_num: 19 "
content.lda.model <- content.lda.list$lda_model
content.lda.list$lda_plot
5.1 Terms for 5 topics as an example
complain.topics <- topicmodels::topics(content.lda.model, 1)
## In this case I am returning the top 30 terms.
complain.topics.terms <- as.data.frame(topicmodels::terms(content.lda.model, 30),
stringsAsFactors = FALSE)
print(xtable(complain.topics.terms[,1:5]),
type="html",include.rownames = FALSE)| Topic 1 | Topic 2 | Topic 3 | Topic 4 | Topic 5 |
|---|---|---|---|---|
| bodi shop | consum forum | gear box | extend warranti | book amount |
| bill amount | sale execut | good condit | purchas elit | full amount |
| ac vent | toll free | poor qualiti | driver side | tyre tyre |
| driven kms | ac proper | registr number | rd free | sale man |
| proper respons | full payment | warranti period | ab system | warranti expir |
| assembl chang | paid amount | exchang bonus | engin oil | book price |
| consum forum | registr number | middl road | exact status | elit aug |
| deliveri accessori | advanc amount | repeat request | experi bad | insur polici |
| front rear | amount refund | steer wheel | fog lamp | ko kaha |
| huge amount | clutch plate | clutch plate | goyal ludhiana | purchas mileag |
| power window | spare wheel | free cost | loan approv | rude behavior |
| vide invoic | due neglig | front tyre | pressur plate | tyre side |
| align proper | feedback repair | recent purchas | road price | ab model |
| amount deliveri | front bumper | respons care | book book amount | book book |
| bad experi | indian road | uttar pradesh | dash board | check engin |
| book cancel | insur claim | batteri batteri | full amount | cng kit |
| cost readi | invoic number | earn money | labour charg | commit deliveri |
| defect steer | met accid | final bill | poor pickup | elit petrol |
| deliveri delay | price book | fuel pump | price price | extra amount |
| full payment | repair cost | local tyre | purchas purchas | fog light |
| gear box | repair proper | mithila road | raini season | front side |
| ludhiana punjab | road branch | paid advanc | registr certif | humbl request |
| mud flap | side rear | status deliveri | registr fee | k kilomet |
| proper repli | total km | wheel balanc | santa fe | kar ke |
| reason cancel | hard earn money | cng kit | status deliveri | loan amount |
| road lucknow | air condit | deliveri deliveri | strict action | loyalti bonus |
| sale person | amount paid | deliveri receiv | accid front | nois engin |
| short period | attach photo | detail mention | amount deliveri | number plate |
| sport model | book elit | dsc nandanam | book model | power steer |
| wheel balanc | chang part | elit sport | brake pad | regist number |
# Creates a dataframe to store the complaint Number and the most likely topic
doctopics.df <- as.data.frame(complain.topics)
doctopics.df <- dplyr::mutate(doctopics.df,
complain_id = rownames(doctopics.df))
colnames(doctopics.df)[1] <- "topic_id"
doctopics.df$complain_id <- as.integer(doctopics.df$complain_id)
## Adds topic number to original dataframe of lessons
comp_topicDF <- dplyr::inner_join(compDF, doctopics.df,
by = c("S.No."="complain_id"))5.2 All topics with 5 top terms
topicTerms <- tidyr::gather(complain.topics.terms, Topic)
topicTerms <- cbind(topicTerms, Rank = rep(1:30))
topTerms <- dplyr::filter(topicTerms, Rank < 6)
topTerms <- dplyr::mutate(topTerms, Topic = stringr::word(Topic, 2))
topTerms$Topic <- as.numeric(topTerms$Topic)
topicLabel <- data.frame()
for (i in 1:length(complain.topics.terms)){
z <- dplyr::filter(topTerms, Topic == i)
l <- as.data.frame(glue::collapse(z[,2], sep = "|" ),
stringsAsFactors = FALSE)
topicLabel <- rbind(topicLabel, l)
}
topicLabel <- cbind(topicLabel,rownames(topicLabel))
colnames(topicLabel) <- c("Label","topic_id")
topicLabel$topic_id <- as.numeric(as.character(topicLabel$topic_id))
comp_topicDF <- dplyr::inner_join(comp_topicDF,topicLabel,by="topic_id")
print(xtable(topicLabel),
type="html",include.rownames = FALSE)| Label | topic_id |
|---|---|
| bodi shop|bill amount|ac vent|driven kms|proper respons | 1.00 |
| consum forum|sale execut|toll free|ac proper|full payment | 2.00 |
| gear box|good condit|poor qualiti|registr number|warranti period | 3.00 |
| extend warranti|purchas elit|driver side|rd free|ab system | 4.00 |
| book amount|full amount|tyre tyre|sale man|warranti expir | 5.00 |
| clutch plate|delay deliveri|side door|bad experi|famili member | 6.00 |
| manufactur defect|driver seat|warranti period|front glass|number plate | 7.00 |
| consum court|engin head|wheel align|spare part|chasi number | 8.00 |
| alloy wheel|clutch plate|chassi number|air condition|corpor discount | 9.00 |
| repair work|ac compressor|fit proper|front bumper|nois engin | 10.00 |
| manufactur defect|spare part|front tyre|auto web|book order | 11.00 |
| concern person|part part|hdfc bank|slow speed|bodi cover | 12.00 |
| sale execut|left side|work shop|extra cost|head light | 13.00 |
| show room|music system|book elit|consum court|tyre replac | 14.00 |
| engin oil|top model|sale person|insur claim|black smoke | 15.00 |
| cover warranti|book amount|brought notic|corpor discount|gear gear | 16.00 |
| insur claim|part replac|engin engin|model deliveri|steer jam | 17.00 |
6 Topic Visualization
6.1 Topic Distances and term relevance
comp_keywordsDF.reduced <- comp_keywordsDF[comp_keywordsDF$ID %in%
doctopics.df$complain_id,]
m <- list(id = "ID", content = colnames(comp_keywordsDF.reduced)[2])
myReader <- readTabular(mapping = m)
complain.corpus <- VCorpus(DataframeSource(comp_keywordsDF.reduced),
readerControl = list(reader = myReader))
complain.json <- topicmodels_json_ldavis(content.lda.model,
complain.corpus, content_DTM.uncl)
serVis(complain.json,
out.dir = 'vis2',
open.browser=FALSE)6.2 Topic correlation
word.topics <- as.data.frame(t(topicmodels::posterior(content.lda.model)$term))
word <- rownames(word.topics)
word.topics <- cbind.data.frame(word,word.topics,
stringsAsFactors = F)
num.col <- ncol(word.topics)
corrplot(cor(word.topics[,2:num.col]), method = "circle")
topic_name <- c()
# create topic names using first five words
for (i in 2:num.col){
top.words <- word.topics[order(-word.topics[,i]),1]
topic_name <- c(topic_name,
paste(top.words[1:5], collapse = "|"))
}
# rename topics
colnames(word.topics) <- c("word",topic_name)6.3 Topic Clustering
m <- as.matrix(t(word.topics))
# # # m <- m[1:2, 1:3]
distMatrix <- dist(m[2:nrow(m),], method="euclidean")
#print(distMatrix)
#distMatrix <- dist(m, method="cosine")
#print(distMatrix)
groups <- hclust(distMatrix,method="ward.D")
par(mar = c(4,1,1,12))
dend <- as.dendrogram(groups)
#library(dendextend)
# Horizontal plot
dend %>% set("branches_k_color", k = 10) %>% plot(horiz = TRUE)
dend %>% rect.dendrogram(k = 10, horiz = TRUE, border = 8, lty = 5, lwd = 2)
abline(v = heights_per_k.dendrogram(dend)["10"], lwd = 2, lty = 2, col = "blue")
6.4 Community detection
6.4.1 Static networks
cor_threshold <- .2
cor_mat <- cor(word.topics[,2:num.col])
cor_mat[ cor_mat < cor_threshold ] <- 0
diag(cor_mat) <- 0graph <- graph.adjacency(cor_mat, weighted=TRUE, mode="lower")
# E(graph)$edge.width <- E(graph)$weight
# V(graph)$label <- paste(1:(ncol(word.topics)-1))
#
#
# par(mar=c(0, 0, 3, 0))
# set.seed(110)
# plot.igraph(graph, edge.width = E(graph)$edge.width,
# edge.color = "blue", vertex.color = "white", vertex.size = 1,
# vertex.frame.color = NA, vertex.label.color = "grey30")
# title("Strength Between Topics Based On Word Probabilities", cex.main=.8)clp <- cluster_label_prop(graph)
class(clp)[1] “communities”
plot(clp, graph, edge.width = E(graph)$edge.width, vertex.size = 2, vertex.label = "")
title("Community Detection in Topic Network", cex.main=.8)
V(graph)$community <- clp$membership
V(graph)$betweenness <- betweenness(graph, v = V(graph), directed = F)
V(graph)$degree <- degree(graph, v = V(graph))No particular clusters found
6.4.2 Dynamic visualization
visIgraph(graph)7 Sentiment Analysis
sentiment_syuzhet <- get_sentiment(comp_topicDF$complaint_summary)
sentiment_afinn <- get_sentiment(comp_topicDF$complaint_summary,method="afinn")
sentiment_bing <- get_sentiment(comp_topicDF$complaint_summary,method="bing")
sentiment_nrc <- get_sentiment(comp_topicDF$complaint_summary,method="nrc")
comp_topicDF <- cbind(comp_topicDF,
sentiment_syuzhet,
sentiment_afinn,
sentiment_bing,
sentiment_nrc)
comp_topicDF <- as.data.frame(comp_topicDF %>%
rowwise() %>%
mutate(sentiment_averaged = mean(c(sentiment_syuzhet,
sentiment_afinn,
sentiment_bing,
sentiment_nrc), na.rm=T)))7.1 Visualizing Syuzhet sentiments
create_group_plots(comp_topicDF,
"sentiment_syuzhet",
"Label",
10)
7.2 Visualizing Bing sentiments
create_group_plots(comp_topicDF,
"sentiment_bing",
"Label",
10)
7.3 Visualizing Afinn sentiments
create_group_plots(comp_topicDF,
"sentiment_afinn",
"Label",
10)
7.4 Visualizing NRC sentiments
create_group_plots(comp_topicDF,
"sentiment_nrc",
"Label",
10)
7.5 Visualizing Averaged out sentiments
create_group_plots(comp_topicDF,
"sentiment_averaged",
"Label",
10)
7.6 Sentiment Word cloud
content_DTM.uncl_df <- as.data.frame.matrix(content_DTM.uncl)
content_DTM.uncl_df$id <- rownames(content_DTM.uncl_df)
tmp <- comp_topicDF[,c("S.No.","sentiment_afinn")]
names(tmp) <- c("id","sent")
tmp$id <- as.character(tmp$id)
content_DTM.uncl_df <- inner_join(content_DTM.uncl_df,
tmp,
by=c("id"))
content_DTM.uncl_df <- cbind(sentiment=ifelse(content_DTM.uncl_df$sent > 0,
"positive",
ifelse(content_DTM.uncl_df$sent < 0,
"negative","neutral")),
content_DTM.uncl_df)
sent_levels <- levels(factor(content_DTM.uncl_df$sentiment))
labels <- lapply(sent_levels,
function(x) paste(x,format(round((length((
content_DTM.uncl_df[content_DTM.uncl_df$sentiment ==x,])$id)/
length(content_DTM.uncl_df$sentiment)*100),2),nsmall=2),"%"))
sentiment_words_df <- as.data.frame(content_DTM.uncl_df %>%
select(-id,-sent) %>%
group_by(sentiment) %>%
summarise_all(sum))
rownames(sentiment_words_df) <- labels
sentiment_words_df <- sentiment_words_df %>%
select(-sentiment)
word_sentiment_mat <- t(as.matrix(sentiment_words_df))7.6.1 Sentiment Word cloud for bi and tri grams
# comparison word cloud
comparison.cloud(word_sentiment_mat,
max.words=100,
rot.per = 0.15,
colors = brewer.pal(3, "Dark2"),
scale = c(2.5,.25),
random.order = FALSE,
title.size = 1.5)
8 Topic summarization
8.1 Summarization for each Topic
topic_summary_DF <- data.frame()
for(top_id in unique(comp_topicDF$topic_id))
{
temp_df4sum <- comp_topicDF %>%
filter(topic_id == top_id)
temp_sum_df <- lexRank(temp_df4sum[,"complaint_summary"],
threshold = 0.18,
n=ceiling(nrow(temp_df4sum) * 0.1),
Verbose = FALSE)
topic_summary <- c(topic_id=top_id,
topic_summary_txt = paste(unique(temp_sum_df[,"sentence"]),
collapse=" \n"))
topic_summary_DF <- rbind(topic_summary_DF,topic_summary,
stringsAsFactors =FALSE)
names(topic_summary_DF) <- c("topic_id","topic_summary_txt")
}
topic_summary_DF$topic_id <- as.numeric(topic_summary_DF$topic_id)
topic_summary_DF <- inner_join(topicLabel,topic_summary_DF,
by = "topic_id")
print(xtable(topic_summary_DF),
type="html",include.rownames = FALSE)| Label | topic_id | topic_summary_txt |
|---|---|---|
| bodi shop|bill amount|ac vent|driven kms|proper respons | 1.00 |
Upon delivery i was not provided with mud flaps as part of standard accessories, but the same was charged in bill The wheel alignment wasn’t done properly and car tilts on left I specified that car tyres have nitrogen which both, the delivery guy and advisor, confirmed the top-up just to realise after 4 days when I felt the pressure was low that none of the tyres were inflated and were showing 25/26 nitrogen pressure No When my second service was due after 10, 000 kms, I gave them my car for pick up, service and delivery back on Oct 25(my wedding day), I told them clearly that today is the wedding day and only take it if you promise delivery by 3 pm as we’ve do get into work right away at 3 and would require the vehicle Very very worst experience in my life Today when I have faced the issue again when car was behaving abnormal and the music system gets off & on within seconds and horn was not working, lights were not working, power window and central locking were also not functional, at that time I have recorded the abnormality of the vehicle into the Video clip in which you can realize that music system gets on & off by noticing the sound, within a second and the temperature of car was on cool side when car was running with the speed of 60kmph I have booked i20 Elite with Sales Executive Majunath on 23rd Feb, 2015 who promised me to deliver the car with in 2 months I have bought brand new Grand i10 Magna 2 months back and driven only for 1852 kms No follow up calls from Hyundai to give an update, in fact I have been calling them to get an update & every time i call there is a common response we will get to you (which never happens) hi, this is regarding the cancllation charges which are being charged to me and never old to me at the time of booking, can you let me know how much do u charge if there are any for cancellation I booked Grand i10 in Talwar Hyundai Begumpet, Hyderabad branch, the way tehy respond is worst and they dont know how to talk to a customer When I was driving uphill road, it was unable to take load, it was not moving upward in third and second gear, when I shifted to first gear and accelerate, it was asking for second or third gear and I had to stop the car in the middle of uphill road, this caused a lot of panic to me and my family, then with the help of some other people i could manage the situation today that they found one of the battery was faulty after thorough checks and the battery need to be sent to the battery company to get their feedback They did some repair and informed me that everything is fine and asked me to monitor for 2 to 3 days and give them the feedback Though i have the Bill but that Bill is of no use because even after my repeated calls to the advisor regarding the Bill amount he was not ready to give the exact status of the Vehicle or the Bill amount 2013, but after driving the car i came to know that, i am facing same problem which was earlier with old shocker, i had went to Goyal Hyundai ludhiana service station, they are not ready accept any complain This is Vikram Vij from Ludhiana Punjab, i had put a new left side shocker of my Getz car on dated 27 we purchased hyundai i20 from Goyal Hyundai, Ludhiana PUNJAB about 25 days ago having VIN: MALBB51BLDM545679 but due to discomfort i checked it yesterday at an alignment centre outside,then i came to know that it was not able to align properly as its tyre roadend was complaint and my tyre was got discarded due to that i would like to know then how the popular team had told me that it was done and gave me the bill But the concerned person made the huge amount of estimate bill that my insurance company denied to pay the dues as mentioned in estimate If this is the way customer is treated in Hyundia motors then i will not suggest anyone to buy the Hyundai motor product I received the xcent car on 20-10-2016 after permanent registration through the dealers In the brochure, it is written that the model have Airbag, ABS, Central locking, Front power window etc 2 uk08x5234 clutch plate assembly was changed in mid august 2016 at rama hyundai service center new delhi while driving burning smell was coming so i went to the service center to know about the issue Due to some reason i have cancelled the said booking on 11-08-2016 from my mail id nareshshah@zyducadila I have booked one hyundai creta vehicle on 27-07-2016 in company’s name cadila healthcare ltd Towed the vehicle to service station and after investigation, the adviser said that the clutch assembly needs to be changed as it got damaged (Wear and tear) After second service (After 10000 km), i had a clutch issue around 11k km and was not able to shift gear |
| consum forum|sale execut|toll free|ac proper|full payment | 2.00 |
I have booked for Hyundai grand i10 ASTA model petrol variant on December 5th & paid a token amount for booking the colour & model as advised by the sales executive I have approached several departments of the company complaining about the tyres defect and no one is listening to my problem On 19th Dec’14 we brought Hyundai Grand I10 Magna from SPS Hyundai - Thiruvallur, On 30th Dec’14 we went to Thirunalvelli & the running condition left side rear tyre got puncher & we replaced the spare tyre When we given the puncher tyre to local puncher shop they told us we can’t repair the puncher & the tyre got worn out My car AC was working fine accept some noise that came couple of times, accept that there was no problem in the AC of the car regarding to buy hyundai i-10 grand, but sales executive Shamim Doesn’t provide me proper information and misbehaved during call he was talking to another peoples also, i also called at reception then receptionist said you will get a call back within 5 minutes but not get any call from their end please take strict action against Himgiri hyundai First incidence - Called sales executive and told interested in i10 hyundai car petrol since we dont use enough |
| gear box|good condit|poor qualiti|registr number|warranti period | 3.00 |
When the engine is on then the gears are not working, if engine is off and change the gear works ok I informed the customer care immediately and a police complaint was also lodged After that also when I called them again and told them to sent a mail to me regarding the delivery date, he is like he do not have the right to sent an email regaridng the delivery date Some how, after confirmation from the Dealer at Jaipur, I got the battery replaced at Baroda with the assurance that the cost of battery will be refunded to me after surrender of the defective battery at Jaipur within less than three months time, the battery (Exide) was out of order, when I was at Baroda (Gujarat) & was going to Ahmedabad with my family My hyundai creta broke down in the middle of the road in the middle of the night/ My younger brother also contacted to the capital hyundai sector 63 noida (Up) & met to the general manager there & asked him to look into the matter so that it could be understood the problem occurred in creta sx+ car that it ddi not start for around four hours I called to the hyundai service assistant who give us the complaint no 47236 & which came late to help but the engineer brought the battery while there was no battery issue but the vehicle was not getting started |
| extend warranti|purchas elit|driver side|rd free|ab system | 4.00 |
But now when i asked the delivery date he is telling he will deliver the car in mid of feb 2015 Few days i got call from concerned person from showroom saying that the car will be available in showroom 12th jan onwards any time u can take deliveryAfter 4 months I received RC book but instead of my car model SPORTZ it was stated MAGNA I have purchased Hundai I-10 Sportz on 3-1-2014 from Hundai show room ie RITU AUTOMOBILE PVT The problem was further compounded since the car dealer retained the original Registration, Insurance and other documents with him since last one week and I was exposed to harassment to the traffic All formalities for my Bank Loan from M/s HDFC Bank was completed and loan was approved Date of Purchase :- 23rd June, 2017, all formalities were completed As on date i can’t get exact status for when my car will be receive after repairing Every time your show room person saying after two week it will be receive I had to change the pressure plates, brake pads, key sets 3 times and now my ecm is damaged I am using my vehicle for the past 4years and am receiving complaints frequently in its parts I followed up with the dealer in Jhansi(since I made a deposit to him and he was the sales manager of Jhansi) on 20th april, and he said he didn’t booked the car yet because he was waiting for the loan to be approved from HDFC bank I placed an order for Hyundai verna automatic variant on 6th april, for which dealer asked me to make a deposit of 1lac (whereas on Hyundai website, they shows ZERO down payment) so he can book the car and bring it within 20days from chennai manufacturing plant, since it is automatic he didn’t had it in his yard I am giving my car for regular service but they said your car doesn’t need service but your clutch is not working properly then i decided to change the clutch plate but when i get the car, clutch is not properly working and noise in silencer and silencer bolts are remove then they said we have to work for silencer then take bake the car and after that when they send the car silencer noise same then they said your silencer is totally failed but that time they charged me 11000 rs THIS IS hyundai motor dealer and service center procedure The authorised service people is confused to identify the complaint and the suggest to remove the clutch pressure plate fully and gave a estimate The car is regularly serviced by above said authorized dealer and they saying that it is complaint of Clutch and it should be replaced I have paid full amount for CREATE 1 So far I haven’t received any message regarding the vechicle allotment Car no - GJ 6 FK 5958 Santa Fe bought in February 2013 I have discussed said problem with there service center & given vehicle two times to solve the said problem but said problem till the time not sort out from them I have purchased i20 elite from Ishanya Hyundai, Pune, in Jan-2015 and after first servicing after 500 KM I faced hard brake problem at slow speed During the pre-booking the sales person mislead me about the extended warranty stating that it will cover 2 free services in the 3rd year but after booking the car they didn’t mention it in the booking order and never gave me a copy of that I am not satisfied with it’s abs system as well as service center service ( Bonnet setting and other work) Once one phone call from pioneer hyundai to come service center but they are not providing me home service Now i am afraid that your service center is not interested to resolve my problem early and i am not setisfied with abs system of the car so many time break is not working properly LASTLY, AT 38000KM TODAY I WENT TO ARVIND HYUNDAI THEY TOLD ME THE CHARGE 5000/-, AFTER FEW HOURS THEY SAID BRAKE PAD & DISK BRAKE THY SAID YOU HAV TO PAY 10000/-, AND NOW THEY ARE SAYING YOU HAVE TO PAY 14000/- THERE IS MANY PROBLEM IN VEHICLE i bought the i 20 sportz model on november 2013 from your authorised dealer Goyal hyndai ludhiana and when i done it with its 1 service on 1000 km i notice that my car headlight which is on right side are covered with fog from inside and i mention the problem to the one advisor that my car headlight is having fog from inside he tells me no problem in sunlight i work gud and fog will soaked up and on second time service which on 10000 km when i have done it same problem again repeat i told to him that problem again repeats he told me no problem sir your car is in warranty i will change your light under warranty and my car met with an accident after that from that side and the lupperlock of headlight breaks down when i got repair the car same problem again occur and now when i got the time to change my headlight they said that lock was broken so we cant change your light I bought new care Grand i10 Sportz SE from Brar Hyundai, Kotkapura (Punjab) and I experienced the most pathetic after sale customer service from their end Every time they make false promises even though after paying the full amount on day of the purchase (07/01/2017) till yet I havent received my Cars Second key and seat covers for that whenever I call them and visit there, they make excuses every-time I recently had an issue with my 2014 i20’s abs system, it seems that the right lymph sensor wasnt working properly, so i had it replaced on the 16/01/2017, i had to place the car in MCP HYUNDAI VELLANGHALLUR custody for 1 day and picked up my car on the next day I am hyundai coustmer and i am very upset that my car Santa fe is lying in one of your workshop for 14 days and they are saying that hyundai part will come and then we will assembled |
| book amount|full amount|tyre tyre|sale man|warranti expir | 5.00 |
5000/- as a booking amount when the sales person assured me if in any case loan amount not sanctioned or for any reason I cancelled the booking they refund all my booking amount CAR PROBLEM maine HUNDAI KE EON SPORTS car jabalpur se Prestige Hyundai se 29 june ko le the aaj tak uske 2 baar bettery change ho chuke hai or kam se kam 20 baar bettery down ho chuke hai The Manager said that the car is ready and will be delievered on February, 7 and asked us to pay the full amount More than that The Company is not responding well and The Manager is not paying any attention to any of our queries As i am regular user of hyundai cars so the i was eligible for the loyalty bonus Amt Rs 15000 Instead of repeated calls there has been no answer from the company After taking delivery of the car, Peeyem Hyundai thalassery had never responded to me nor attended to my grievances so my humble request is to kindly attend to my grievances and I also request you to kindly look in to this and don’t let my confidence and trust on the Hyundai |
| clutch plate|delay deliveri|side door|bad experi|famili member | 6.00 |
Please take this matter as serious as I am facing a big issue as from the starting I am facing a problem and after paying and changing Clutch plates two time, the same problem is persisting I am extremely dissatisfied with the action of the Hundai Motor India Ltd and Dee Hundai Motor service station at Lukerganj, Allahabad and Insurance company who declared that action should be taken time bound and result oriented Let me be clear on the fact that I am fine with the genuine delay in delivery of the car, but I am extremely dissatisfied with how the customer service representatives treat their clients at Hyundai Please find here details of my grievance - I have placed an order for Hyundai Xcent base - Pristine Blue at Kanchan Hyundai Showroom at Udupi, Karnataka on 26th March 2014 sir plz do some thing for my car key I am facing lots of problem due to key I ask hyundai service centre they told me it will cost 15 thousand but I m not ready to buy this Tommorrow when I used my car find oil level indication on dash borad and find oil leakage from engine Now my car is at Longowal, which is 30 km from service center i |
| manufactur defect|driver seat|warranti period|front glass|number plate | 7.00 |
However, when the car was delivered back to my residence the Power Steering was not working and car was showing EPS sign on the dashboard Also timely delivery is promised only if we take finance from their tied up finance company, otherwise delivery will be delayed After some day Received call from Concept Hyundai again and they pick up my car from my home to get it sorted and drop car at evening At that time I mentioned about my reverse gear problem but it did not resolve at that time And when i called him for my remote lock and car perfume (for which i already paid and still not receive) he behaving very rudely with me (M B Hyundai) on 15/06/2017, at the time of taking car for repairing service adviser promised me to deliver my car on 06/07/2017 but today went service center to take my car My car is not ready for delivery and asking for more three days for delivery The front glass windshield of my car devoloped a crack while the car was parked in my hospital parking I feel ditched and i’m planning to move to consumer court to complain about this substandard quality The vehicles are just left without rto tax receipt & number plate in the buyers building I had booked Hyundai i10 grand asta automatic through Ritu Hyundai It is my second worst experience about hyundai car’s dealers and its company |
| consum court|engin head|wheel align|spare part|chasi number | 8.00 |
The customer care manager - manu (From the karamana branch) has called me and asked me to pay rs 20000 towards replacement of the entire clutch system in elantra Do necessary action to do so otherwise I will go to consumer court I told them that first i clear from bank if they said that give them 1707 then i will give you When they book my car they assured that delivery within 10 to 15 days they told that the car will be delivered in 30 days of the booking I Have booked my i20 on 19th July in susee Hyundai madurai I bought this car from Popular Hyundai, Popular motor world private limited, Muvattupuzha, Ernakulam dist Just after 1st service, its A/C is not working 1) Within the first 300 kms of my purchase of the car, the wheel alignment went off centre to LH This was a clear product failure at such a low mileage and warranty denial is totally not acceptable to me AT THE TIME OF PURCHASE I WAS ASSURED THAT AS PER THE HYUNDAI ASSOCIATE SCHEME JULY 2014 I AM ENTITLED FOR REFUND OF RS 11500/-AS ADDITIONAL BENEFIT AND RS 3000/(TOTAL 14500)-AS CORPORATE BONUS FROM HYUNDAI INDIA CORPORATE OFFICE I AM SORRY TO INFORM YOU THAT I HAVE TIME AND AGAIN APPROACHED BERKELEY HYUNDAI CHANDIGARH BUT EVERY TIME THEY HAVE REPLIED THAT CASE HAS SINCE BEEN FORWARDED TO HYUNDAI OFFICE I have purchase a car Hyundai i10 on 31/07/2013 from Hisar Hyundai, Hisar dealar At that time they told me about corporate bonus and exchange bonus Sub: Excessive black smoke emission and replacement of car and a few days back I also refer my brother for taking car from Hyundai showroom, at that time popular executives says that you will get referel benefits of rupees 3000 petrol voucher, and my brother took grand I 10 from Hyundai popular muvattupuzha Other wise no one will refer muvattupuzha popular hyndai for purchasing a car, actually these employees are distorting the reputation of hyundai, am very sad to say like that I have given my hyundai verna car for repair on akashdeep hyundai service centre sambalpur Odisha, they told me that they will deliver the car within 10, after 15 day they are saying that till now they don’t have spare parts, spare parts we have ordered but don’t know when it will come, than again i have requested for spare delivery time & car delivery date they are rudely reply that we don’t know whether spare is coming from Korea or chennai, I just wanted to know that whether car bummer, fog lights is not available in India Is it the way hyundai is behaving with customers They had provided poor servicing as well as they had disturbed my wheel alignment and due to this my both front wheel has completely damaged where as my car has run only 8070 k I shall make a complaint against the hyundai show room regarding this poor servicing and disturbed my wheel alignment I was facing a problem of Black Smoke from my Fluidic Verna and got it checked from service center This is regarding the problem which I have just encountered and investigated by Dharamshree Automobile Pvt the staff is very irresponsible they have given my car from last 15 days still they dont have spare parts everyday i have to visit them and ask them to do some work on my car that i 20 elite |
| alloy wheel|clutch plate|chassi number|air condition|corpor discount | 9.00 |
respected sir i have purchased i 20 at 30- 19-2013 at the time of purchased deler told me that i am a doctor we will give you corporate discount rs 5000 and now he told that if u r ima member then only i will give u corporate discount but i am also doctor i have my medical certificate and i am also submit all document I request you to kindly help me return my entire amount as i am now no more interested in buying vehicle from this showroom under these circumstances Neelam singh 09451171749 Ive also compared with other same vehicle of hyundai of my friends the cooling and time to be taken in cooling and i found that my vehicle is not upto the mark as far as AC system is concerned Hyundai, Malviya Industrial Area, Jaipur, Rajsthan and they checked and assured both the times that the AC is working good But, I’m not convinced and satisfied by its performance air conditioner of my car stopped working in just 2 i went to dealership and they changed a rely kit hello sir maine abhi 5 months pahle hi car li thi jo ki abhi sirf 3000 kms hi chal payi hai wo b sirf single hand me hi rahti hai aur koi nai chalata aur bahut hi safely chalti hai phir b itni jaldi uski clutch plate kharab ho gayi iske pahle first service ke time b clutch me problem thi par service ke bad use thik bataya gaya aur kah rahe hai ki apki fault hai compamy ki nai par maine to pahle hi complaint ki thi iski par ab charges kyo Air conditioner of my i20 elite car was not working I visited in hyundai work shop shastri nagar kanpur on 27 I own Hyundai Grand I-10 & my chassis number is : MALA851CLEM115801 |
| repair work|ac compressor|fit proper|front bumper|nois engin | 10.00 |
COMPANY WILL GIVE U EXCHANGE OFFER IF U HAVE ANY OLD CAR so kindly do needfull above matter if you not solve thise problem kindly take your car back 2014 but now 22 days have gone, my car is still not repaired and saying that parts are demanding from Hundai Company My met with an accident during damaging the front bumper and collent of the vehicle MY CAR SCHEDULE FOR SERVICE AND REPETTED COMPLAINTS IN YOUR WORSHOP:- 1)25 JUNE 2013 FREE SERVICE(NOT EVEN CLEAN THE DUST IN THE CAR) 2)16 JULY 2013 COMPLAINT FOR BLUETOOTH AND SILENCER SMOKE 3)16 OCT 2013 COMPLAINT FOR BLUETOOTH AND SILENCER SMOKE 4)04 FEBRUARY 2014SECOND FREE SERVICE (THE DRIVER WHO CAME TO PICK UP THE CAR HITTED THE FRONT BUMPER) 5)17 APRIL 2014 COMPLAINT FOR BLUETOOTH AND SILENCER SMOKE(WORST COMPLAINT ATTENDED BY MR after completion of work he told me now the same problem will not be again for silencer smoke and he has clicked the photographs of sound system which he will change in 7-8 days and he also said if satisfaction phone comes from the company dont tell them about the cmplaint Now, this is the last complaint from my side that you must take immediate action to replace the windows as it is in period of warrenty other wise i will be forced to complaint to Cunsumer Forum But windows are not fitted Properly and so it’s not working and it has been shown to showroom for 3-4 times but still the problem is as it is Most Of the Hundai I10 Having the ECM complaint after 20000Km , unfortunately my I10 also having the same complaint and when i visited the workshop , says that need more than Rs30000/- for replacement, And This is the common complaint for most of the Hyundai I10 cars hence need to replace the ECm at free of cost I would certainly go to the consumer court and sue Hyundai for such blunder if the case is not resolved within this week But saw my car they are removing my back bumper and wiring panel and and the complete set (There is no damage in back bumper) and fixing an old repainted bumper, they removing my orginal parts (Back bumper and right side mirror) of my car and fixing an old parts My name is basil baby and am purchasing a brand new hyundai elite i 20 sportz (Kl 17 p 1686) in april from popular hyundai muvatupuzha (Popular motor world pvt ltd, 6/567b, nh 49, perumattom, muvattupuzha 686673) in october month my car met an accident and my cars front bumper broken and few bents are there |
| manufactur defect|spare part|front tyre|auto web|book order | 11.00 |
I told them that i will insure my car from new india insurance but they rejected my choice and took 28000 rs for insurance which was of just rs 16000 and told me that its hyundai company rule to have insurance from showroom itself i wanted it in written but they did not provided me Then came the last billing they took more 10000 rs in final billing saying that the price of car has been increased apollo tyre representative said tyre is not replaced because it is due to impact but in my knowledge there is no impact but it is a manufacturing defect i was using i20 car since last 11 months[ purchased on 15 june 14], recently i have noticed a Bleb on driver side tyre, for which i visited to royal hundai gwalior, they give me a toll free no IF THE COMPANY IS UNABLE TO PROVIDE THE SPARE PARTS IT SHOULD COMPENSATE THE CONSUMER FOR THE INCONVENIENCE OR PROVIDE IT WITH A TEMPORARY VEHICLE TILL THEY ARE ABLE TO REPLACE THE PART before all the Tyre getting damaged you have to service all the Tyre before it had damaged The work is not satisfaction third service in my car TN 72 AH 1062 when ever any part of my car is to be replaced the price of dealer of company is 4- 5 times of the price it is available in cities like delhi, for instance, i was asked to replace the self of the car of which the price demanded my company is 18000 which was too much for me and so i enquire it outside the showroom for the same company part and which i purchased it for just 5000 from delhi of same manufacture and that too with the help of some mediator who deals in bringing spare parts of vehicles from other cities , so naturally he must have earned in it some thing atleast The list of the parts is necessary to know, because when we go to the garage of the dealer for repairing of the car and if any part is found damaged and needs replacement, then the authority of the dealer says that, the parts not within the Extended Warranty I am a owner of verna fluidic and i have extended the warranty in last december, there was a fault in reverse braking system and a technician from srishti hyundai rohtak told me that one of the spare part is out of stock for now so you can opt for warranty exend and when this part arrives in service centre it will be replaced in warranty so what’s the use of such cars for which we have to wait for 1 years for spare parts |
| concern person|part part|hdfc bank|slow speed|bodi cover | 12.00 |
I have faced a lot of problems in the car regarding the quality of parts used in the product Vehicle History, Date on 25/02/2014 at 7766 km vehicle was having issue of clutch The service center has rectified the rectified the problem with the clutch and Overhaul the clutch system under billable basis and vehicle was o Then again on 16/12/2015 at 16663 km (odometer) vehicle brake down and wer took the vehicle to nearest service center (S8803:-Advaith Motor, Ramnagar) and then there find the same clutch issue and replaced the whole things on billable basis I have been promised first time delivery date of 16/05/2015 by dealer (Kundan Hyundai, Thermax Chowk, Chinchwad, Pune contact no-020-66331129 I am having I20 Magna Diesel car with reg no AP04AS4786, getting the mileage 10 Kind attn, i want to take to your attention towards my complaint that i had registered with you on complaint no 1-663314745 12/1/2014 after this complaint the dealer sent me his guy who sold me the car & he ask for the apology & he make an promise to me that they will full fill all there promises that they had made with me & they ask me to sign an letter in that it was written than i am satisfied & i want to take the complaint back as the guy said to me if I did not sign this paper than dealer will take away my job so I thought that i must cooperate with this guy but from that time no one ever come to me or ever give me a call & now I came to know that Samta Motors Ambala has closed his business also they had closed sales & everything I have the complaint number with me but there is no one to listen to me so i though to write this last email to you & i had attached the previous email & complaint number also if my matter is not resolved sooner i will put all this on the social media and i will put a copy of this email on my all blogs where there are too many visitors are visiting my blogs to read all software and other reviews i will put this on all of your reviews forums I am considering to put a review of the car on various motor and customer review websites for them to know the quality of parts used in the making of the car along with the service one gets Date of Purchase 08-06-2012, the mileage of my car is very bad and the representative is told me that the mileage is improve but the mileage is as it is the mileage of my car is (Petrol:-6kmpl 5kmpl)and i complaint in Hyundai Customer care several time and every time they told me that i forward your complaint at related department We have purchased a grand i10 on 3rd october from deep hyundai Delhi At the time of delivery we are surprised to see that you are providing only one central locking key i have given my vehicle for full servicing with complain in job card clearly mentioned that in my vehicle 2 problems is coming one in clutch another in brake on 14 again since one week back service centre took my vehicle to service centre but till today they are not doing anything I had send the car to the dealer for this problem on 1st weak of july and after cheking the gearbox service advisor of the dealer said that a part of gearbox is not available and he said we will oder the part and it will be comes in 10 to 15 days nd we call you when the part will come But they did not call me nd i had call them after 1 month and they said we will call you in 10 minutes but they didnot call me till yesterday |
| sale execut|left side|work shop|extra cost|head light | 13.00 |
RECENTLY I HAVE FACE MY CAR GOING TO LEFT SIDE & MY STRING IS VERY HARD I have purchased i20 with normal headlamps but at the time of purchase i paid an extra amount of Rs Today 21/01/2017 after 2 & half months when i came to pick-up my car according to call made by me & as said by hyundai then they are unable to deliver my car & also they are not giving certain date of delivery My i20 car Number JH01AH-2262 got accident on 08th Nov 2016 & the car reached in Fairdeal Hyundai Bariyatu Ranchi Jharkhand on 09th Nov 2016 They told me that usually delivery will be done in 2 to 3 months and if you buy or make over the creta at extra cost from modi hyundai by paying extra then they shall manage to give me the delivery of hyndai creta within a months time,,, the person who attented me was more pressurizing me to buy accessories rather then selling creta at his showroom I think modi hyundai is not promoting hyundai brand in fact they are more interested in selling the make over and extra fitting with are available at extra cost at the modi hyundai showroom |
| show room|music system|book elit|consum court|tyre replac | 14.00 |
My car slipped on highway due to this quality issue or technical issue in car and that time whole family in my car hence i am going to launch complaint in legal officer if my tyre is not replaced foc of HMIL I want to replace 3 tyre immediately from Hundai but service engineer told that raised your concerned with tyre vendor |
| engin oil|top model|sale person|insur claim|black smoke | 15.00 |
I m Dheeraj kumar i purchase Hyundai xcent on th17th of July from Samara Hyundai since then i m facing engine oil shortage problem on my first car service i took to my car at 7/20 Kirti nagar samara Hyundai Mr sant kumar was my car service person there i told him my car oil shortage problem he reply i just check it i drop my car there in evening he called me sir your car is ready when i asked him what was the problem he told me nothing i just top up your car after few day’s i again face same problem again i took my car there again he just top up and delivered to me after few day’s i again face same problem again he just top up and delivered to me now i again face same problem again he just tunning
|
| cover warranti|book amount|brought notic|corpor discount|gear gear | 16.00 |
Model: Hyundai I - 20 (Model - Astra - 2011) I have a hundai varna diesal model of 2013 model bought in oct 13 from roorkee Pl depute your representative to visit me before i start regreting of choosing hundai |
| insur claim|part replac|engin engin|model deliveri|steer jam | 17.00 |
From the past few weeks, my son was frequently expressing problem and when approached the showroom the same representative told to approach the service center it will be sorted out, when approached the Hyundai service center, we were told clutch and some other parts need to be replaced and will cost Rs 33, 000/- plus, when asked about guarantee we were told clutch doesn’t come under guarantee Further we were told by service as per their records the vehicle was last serviced on 12th Dec 2013, whereas I bought the vehicle on 19th October 2015 vide their sale agreement number 669 dated 19th October 2014, which means intentionally they haven’t done the servicing and sold it us with many problems in the vehicle and trying to make money now |
9 Output file
output_directory <- "D:/Data Science/Automobile complaint analysis/processed_data"
output_file = paste(output_directory,"/automobile_customer_complain_topics_",
format(Sys.Date(), "%Y%m%d"),".csv",sep="")
write.csv(comp_topicDF,output_file,row.names=FALSE)
print(paste(" \nFollowing output file created - ",output_file,sep=""))[1] " output file created - D:/Data Science/Automobile complaint analysis/processed_data/automobile_customer_complain_topics_20170926.csv"